Even So the following component I am struggling to accomplish following the mass copy and paste has operate I would like A different code that will update column A accordingly these types of that the Task num from sheet 2 will fill in to every in between responsibilities two and Successfully Submitted (Awaiting Approval)